SQL

How to Generate Script for both schema and data using SQL server management Studio 2012

How to Generate Script for both schema and data using SQL server management Studio 2012, someone asked me to explain?
SQL

In this video tutorial tutorial I will demonstrate you how to generate SQL Query Script for both schema and data using SQL Server management Studio 2012.

 

1. Right click on the database and select tasks --> generate scripts

2. Next --> select the requested table/tables (from select specific database objects)

3. Next -- >click advanced --> give types of data to script = "schema and data"

4. Next and click finish button.

 

Post your comments / questions